﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Configuration;

namespace InHD
{
    public class Constants
    {
        public class StoreProcedures
        {
            public class Staff
            {
                public static string GetAllStaffs = "GetAllStaff";
                public static string AddStaff = "AddStaff";
                public static string UpdateStaff = "UpdateStaff";
                public static string DeleteStaff = "DeleteStaff";
            }

            public class Customer
            {
                public static string GetAllCustomers = "GetAllCustomer";
                public static string AddCustomer = "AddCustomer";
                public static string UpdateCustomer = "UpdateCustomer";
                public static string DeleteCustomer = "DeleteCustomer";
            }

            public class Supplier
            {
                public static string GetAllSuppliers = "GetAllSupplier";
                public static string AddSupplier = "AddSupplier";
                public static string UpdateSupplier = "UpdateSupplier";
                public static string DeleteSupplier = "DeleteSupplier";
            }

            public class Product
            {
                public static string GetAllProducts = "GetAllProduct";
                public static string AddProduct = "AddProduct";
                public static string UpdateProduct = "UpdateProductEx";
                public static string DeleteProduct = "DeleteProduct";
            }

            public class Category
            {
                public static string GetAllCategories = "GetAllCategory";
                public static string AddCategory = "AddCategory";
                public static string UpdateCategory = "UpdateCategory";
                public static string DeleteCategory = "DeleteCategory";
            }

            public class Transaction
            {
                public static string GetAllTransactions = "GetAllTransaction";
                public static string AddTransaction = "AddTransaction";
                public static string UpdateTransaction = "UpdateTransaction";
                public static string DeleteTransaction = "DeleteTransaction";
            }

            public class Package
            {
                public static string GetAllPackages = "GetAllPackage";
                public static string AddPackage = "AddPackage";
                public static string UpdatePackage = "UpdatePackage";
                public static string DeletePackage = "DeletePackage";
            }

            public class InvoiceTemplate
            {
                public static string GetAllInvoiceTemplates = "GetAllInvoiceTemplate";
                public static string AddInvoiceTemplate = "AddInvoiceTemplate";
                public static string UpdateInvoiceTemplate = "UpdateInvoiceTemplate";
                public static string DeleteInvoiceTemplate = "DeleteInvoiceTemplate";
            }

            public class Registration
            {
                public static string GetAllRegistrations = "GetAllRegistration";
                public static string AddRegistration = "AddRegistration";
                public static string UpdateRegistration = "UpdateRegistration";
                public static string DeleteRegistration = "DeleteRegistration";
            }

            public class CompanyInfo
            {
                public static string AddCompanyInfo = "AddCompanyInfo";
                public static string UpdateCompanyInfo = "UpdateCompany";
            }
            
            public class Tax
            {
                public static string GetAllTaxs = "GetAllTax";
            }

            public class Account
            {
                public static string GetAllAccounts = "GetAllAcc";
            }

            public class ManagementUnit
            {
                public static string GetAllManagementUnits = "GetAllManagementUnit";
            }
        }

        public class Messages
        {
            public static string DBNotInitialized = "Database is not initialized";
            public static string CannotConnectDB = "Unable to connect DB"; 
        }

        public class Security
        {
            public static string DefaultServer = ConfigurationManager.AppSettings["server"];
            public static string DefaultDBUser = "sa";
            public static string DefaultDBPassword = "1";
        }

        public class DB
        {
            public class Product
            {
                public static string ProductUNK = "@productUNK";
                public static string ProductName = "@proName";
                public static string Description = "@proDes";
                public static string Quantity = "@quantity";
                public static string RetailPrice = "@retailPrc";
                public static string WholesalePrice = "@salePrc";
                public static string ImportPrice = "@importPrice";
                public static string CategoryUNK = "@categoryUNK";
                public static string CategoryName = "@categoryName";
                public static string SerialNo = "@sn";
                public static string SupplierUNK = "@supplierUNK";
                public static string LastAccess = "@lastAccess";

            }

            public class Transaction
            {
            }
        }
    }
}
